USE tempdb

GO

SET NOCOUNT ON

GO

CREATE TABLE LargeRows

(col1 int identity,
col2 char(8000) default '8000 bytes of data');

GO 

INSERT INTO LargeRows DEFAULT VALUES;

EXEC sp_spaceused LargeRows;

GO

select * from LargeRows
go
